specific event, then, check whether the custom view is displayed. Run the command prompt as an administrator on the server1 server, and then run the command "Eventcreate/t error/ID 100/l system/D" Application Error #1 "/SO MyApp ", we can see that the command is successfully executed. Through this command, we have customized an event. The Eventcreate command is used to create Event Logs. The parameter "/T"
Detects if an event is turned onShow variables like ' Event_scheduler ';Turn on EventsSet global Event_scheduler = on;create a stored procedureDelimiter//create procedure test () beginupdate Test fdcreate = Now (); end;Create an eventCreate event if not exists E_teston schedule every the Secondon completion Preservedo call Test ();turn off or turn on execution eventsAlter event event_name on completion preserve [enable | disable]Delete EventDrop event
Event Notifications) to trigger an error in SQL Server. This error will be captured by the previous Server-level event notification.
--Generate a create table eventCREATE TABLE ABC(COL1 INT,COL2 INT)GO--Generate an alter table eventALTER TABLE ABCADD COL3 INTGO--Generate a server level eventRAISERROR (N'Generating error for Event Notification testing...', 16, 1)WITH LOGGO--Review if the events were tracked in queueSELECT CAST(message_body AS XML) A
Mysql DDL DML language, mysqlddlDDL: Data Definition Language
CREATE, ALTER, DROP
Common commands related to CREATE:
CREATE DATABASECREATE EVENTCREATE FUNCTIONCREATE FUNCTION UDFCREATE INDEXCREATE PROCEDURECREATE SERVERCREATE TABLECREATE TABLESPACECREATE TRIGGERCREATE USERCREATE VIEW
CREATE TABLE(1) Create directly;
CREATE TABLE tablename(id INT(11) NOT NULL,name VARCHAR(256) NOT NULL);
(2) create an existing table by querying; the new table is d
icon)" and "L" keys on the keyboard at the same time to achieve the same effect.
4. sysoc. inf: Pull the hidden file
Windows XP hides some system software that you may want to delete or uninstall, such as windowsmessenger, but you can re-display these software. Use the notepad or WordPad program that comes with windows to edit the text file "/Windows/INF/sysoc. inf" and search for and delete the keyword "hide ". Then, go to "Add/delete programs" on the "control panel" and select "add or delete
method of other objects in MySQL.
Here I have a habit: using the table name + '_' + the abbreviation of the trigger type. therefore, for table t26, the trigger is before the event update (see the following points (2) and (3) (Before), then its name is t26_bu.2. Syntax: Time Syntax: trigger timeCreate trigger {Before | after} {Insert | update | Delete}On For each row
Trigger execution time settings: You can set the time before or after an event occurs.
3. Syntax:
(with the XP icon)" and "L" keys on the keyboard at the same time to achieve the same effect.
4. sysoc. inf: Pull the hidden file
Windows XP hides some system software that you may want to delete or uninstall, such as windowsmessenger, but you can re-display these software. Use the notepad or tablet that comes with WindowsProgram, Edit the text file "/Windows/INF/sysoc. inf", search for and delete the keyword "hide ". Then, go to "Add/delete programs" on the "control panel" and select "add
in Processlist, then the event is not turned on and we need to turn it on.Turn on event functionMethod One, through the dynamic parameter modificationSET GLOBAL event_scheduler = ON;After changing this parameter, it takes effect immediately, but the restart MySQL is restored again, that is, the settings cannot be restarted across reboots.mode Two, change the configuration file and then restartIn the [mysqld] section of MY.CNF, add the following, and then restart MySQL.event_scheduler=ON;Once an
Tags: style blog http color io ar data Art div1. Turn events on or off1) See if the event is turned on (two ways) like ' Event_scheduler ' ; SELECT @ @event_scheduler;2) Turn on MySQL events (two ways)SET = 1 ; SET = on;3) Turn off the MySQL eventSET = OFF ; SET @ @global = OFF ; SET = 0 ; SET @ @global = 0;2. Increment and Revise event syntax1) Add (Create) eventCREATE [definer = {User | Current_User}]EVENT[IF not EXISTS]Event_Name onSCHEDULE SCHE
" keys on the keyboard at the same time to achieve the same effect.
4. sysoc. inf: Pull the hidden file
Windows XP hides some system software that you may want to delete or uninstall, such as windowsmessenger, but you can re-display these software. Use the notepad or WordPad program that comes with windows to edit the text file "/Windows/INF/sysoc. inf" and search for and delete the keyword "hide ". Then, go to "Add/delete programs" on the "control panel" and select "add or delete Windows Compon
. However, this example involves processing other events and adding other elements, so it seems a bit confusing. Although programming will be more confusing in the future, it will be hard for beginners to understand, as I did not fully understand it when I first saw it. Then I wrote a Custom Event Process in my console, which is clear and contains fewer impurities. I hope to help you. Of course, I am a beginner. Please correct the problem. FirstCodeAnalyze it again.
Code
Code highlig
)" and "L" keys on the keyboard at the same time to achieve the same effect.
4. sysoc. inf: Pull the hidden file
Windows XP hides some system software that you may want to delete or uninstall, such as windowsmessenger, but you can re-display these software. Use the notepad or WordPad program that comes with windows to edit the text file "/Windows/INF/sysoc. inf" and search for and delete the keyword "hide ". Then, go to "Add/delete programs" on the "control panel" and select "add or delete Windo
shortcut with the mouse, and your computer will be immediately locked. If you think this is not simple enough, you can press and hold the "Windows key (with the XP icon)" and "L" keys on the keyboard at the same time to achieve the same effect.
4. sysoc. inf: Pull the hidden file
Windows XP hides some system software that you may want to delete or uninstall, such as WindowsMessenger, but you can re-display these software. Use the notepad or WordPad program that comes with Windows to edit the te
Create a trigger Grammar:Create TRIGGER Trigger name before|after trigger event on table name for each row execution statementNote: There can only be one trigger event at the same trigger time, such as the before of insert time can only have one departure eventCreate a trigger_time table first:Mysql> CREATE TABLE Trigger_time (Insert_time datetime); Create a trigger that has only one execution statement To create a trigger:Mysql> CREATE trigger DEPT_T
one with the XP icon) and the "L" keys on the keyboard will have the same effect. Http://www.woaidiannao.com
4. Sysoc.inf: Pulling out the hidden files
Windows XP hides some system software that you might want to remove or uninstall, such as Windowsmessenger, but you can let the software show up again. Using Windows's own Notepad or WordPad program, edit the text file "/windows/inf/sysoc.inf" and search for and remove the keyword "Hide". Then you go to the Add/Remove Programs in Control Panel
one with the XP icon) and the "L" keys on the keyboard will have the same effect.
4. Sysoc.inf: Pulling out the hidden files
Windows XP hides some system software that you might want to remove or uninstall, such as Windowsmessenger, but you can let the software show up again. Using Windows's own Notepad or WordPad program, edit the text file "/windows/inf/sysoc.inf" and search for and remove the keyword "Hide". Then you go to the Add/Remove Programs in Control Panel and select Add or remove W
object creates the HttpApplication object through its PR (ProcessRequest) method.III) The HttpApplication object probably creates 19 delegate objects.The HttpApplication object probably creates 19 delegate objects, also known as pipeline events.1th Pipeline EventThe main is the global capture, you can execute a method here, this method than the method of each page executes first. You can also catch an exception, mostly without being caught by try {}catch{}, and look at the source code in detail
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.